Laravel Eloquent update multiple rows with same value but different ID

Ask Time：2020-02-24T00:52:28 Author：Radical_Activity

I'm using Laravel 6 and Eloquent. I'm looking for a way to update a set of rows with a set value, each identified with a unique ID.

This is what I'm doing right now:

$ids = [3948, 1984, 7849, 4456, 394];
$value = false;

foreach ($ids as $id)
{
   User::where("id", $id)->update(["status" => $value]);
}

Is there a way to accomplish the same with only 1 query instead of 5?

Author:Radical_Activity，eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/60364562/laravel-eloquent-update-multiple-rows-with-same-value-but-different-id

More about “Laravel Eloquent update multiple rows with same value but different ID” related questions

Laravel Eloquent update multiple rows with same value but different ID

I'm using Laravel 6 and Eloquent. I'm looking for a way to update a set of rows with a set value, each identified with a unique ID. This is what I'm doing right now: $ids = [3948, 1984, 7849, 445...
Laravel update multiple rows using checkboxes

I need to understand how to use the laravel eloquent way to update multiple rows in a database, based on which checkboxes have been checked. I am using the following code right now, which is workin...
laravel angularjs update multiple rows

i have a sortable table and after successfully moving an item i want to update all the rows in the databasetable which are effected from sorting. my problem is that i dont know what's the best way...
Laravel: Update multiple rows in one query

How can i update multiple rows use laravel eloquent? I want something like: $guest = GuestJointDetail::where('guest_joint_id', $guest_joint_id) ->where('sort_no', '>', $sort_no)
Laravel Eloquent Update Affected Rows count always 1

I am new to laravel. The problem I'm facing is, When I tried to update a column in table with same data using laravel eloquent the affected rows gives me always 1. Here it is the query running
Laravel 5 update multiple rows with different values

I have been searching everywhere for a solution to this, I hope someone has already solved it or has some good ideas for improvement. I am using Laravel 5 and I have come accross a situation where I
Laravel 5 update multiple rows with different values

I have been searching everywhere for a solution to this, I hope someone has already solved it or has some good ideas for improvement. I am using Laravel 5 and I have come accross a situation where I
How to update multiple rows and database with same value at once? Laravel

I'm stuck in code. I managed to create a form that adds a multiple number of rows in db but I do not know how to update them at the same time when i need to use product_code as id. This is table 1 (
How to update multiple rows in sql from array data using laravel eloquent

I was trying to update multiple records in my database using laravel eloquent but is getting errors when trying to update using an array. I am not really sure how to correctly get the data from the
Laravel eloquent update record with minimum value

I need to find the minimum "priority" value and then set it's value to another entry, in place using laravel eloquent. Is there any way to do so or any best practice for it? What I have in mind ...

Laravel Eloquent update multiple rows with same value but different ID

Laravel Eloquent update multiple rows with same value but different ID

Laravel update multiple rows using checkboxes

laravel angularjs update multiple rows

Laravel: Update multiple rows in one query

Laravel Eloquent Update Affected Rows count always 1

Laravel 5 update multiple rows with different values

Laravel 5 update multiple rows with different values

How to update multiple rows and database with same value at once? Laravel

How to update multiple rows in sql from array data using laravel eloquent

Laravel eloquent update record with minimum value

热门文章

jpg图片怎么转换成pdf，详细教程分享！

iphone怎么把图片转成电子版？试试这2个方法！

图片如何转换pdf文件？看看这三个方法！

怎么把图片转换成pdf格式，干货教程不要错过

png图片怎么转换成pdf，实用方法不要错过

图片怎么转pdf格式？三种转换方法分享给你，一分钟轻松解决

图片转pdf格式怎么弄免费？get这五个简单的方法，轻松搞定！

如何将图片转pdf格式？4种转换方法分享给你，一分钟轻松解决

如何图片转pdf免费？快学习这三种免费转换方法

怎么将图片转pdf？分享个图片转pdf在线免费

相关搜索

jpg图片怎么转换成pdf，详细教程分享

电脑图片转pdf工具怎么用

单张pdf图片转照片格式

如何将图片转成pdf文档，经验分享

这么好用的图片转pdf软件，我一定要分享

干货分享，不懂图片转pdf的朋友快快收藏起来

分享一个让你惊叹不已的图片转pdf方法

图片转pdf工具

分享一个大家都不知道的图片转pdf格式方法

好用的图片转pdf软件要和好朋友分享